SELECT *, CASE WHEN `name` LIKE "port washington%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "port washington" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "port washington" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "port washington" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NY" AND (locality IN ("port washington") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$3,999,90038 Country Club DrPort Washington NY 11050View Listing
$2,800,00021 Bayview AvePort Washington NY 11050View Listing
$2,399,00032 Reid AvePort Washington NY 11050View Listing
$1,999,00095 Longview RdPort Washington NY 11050View Listing
$1,799,00012 Longview RdPort Washington NY 11050View Listing
$1,649,00033 Hilltop RdPort Washington NY 11050View Listing
$1,280,000111-113 Mamorhven BlvdPort Washington NY 11050View Listing
$1,229,00043 Sandy Hollow RdPort Washington NY 11050View Listing
$1,225,00030 S Washington StPort Washington NY 11050View Listing
$1,199,00010 Joel PlPort Washington NY 11050View Listing
$1,119,00035 Lewis LnPort Washington NY 11050View Listing
$1,069,00062 Bar Beach RdPort Washington NY 11050View Listing
$925,00035 Neulist AvePort Washington NY 11050View Listing
$899,0007 Neulist AvePort Washington NY 11050View Listing
$849,00039 Shadyside AvePort Washington NY 11050View Listing
$849,00062 Neulist AvePort Washington NY 11050View Listing
$848,0004 Edgewood RdPort Washington NY 11050View Listing
$799,00061 Oakland AvePort Washington NY 11050View Listing
$799,00075 Sintsink Dr EPort Washington NY 11050View Listing
$799,00016 Locust AvePort Washington NY 11050View Listing
$779,0005 Oldwood RdPort Washington NY 11050View Listing
$749,0005 Park AvePort Washington NY 11050View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 6:18:07 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah